inherited FRelatorioNFConferenciaItens_NEW: TFRelatorioNFConferenciaItens_NEW
  Left = 298
  Top = 177
  Width = 861
  Caption = 'VENDAS / FATURAMENTO / RELAT'#211'RIOS'
  OldCreateOrder = True
  PixelsPerInch = 96
  TextHeight = 16
  inherited Panel1: TPanel
    Width = 853
    inherited btnPesquisar: TBitBtn
      Left = 8
      Width = 105
      TabOrder = 1
    end
    inherited lbResultado: TStaticText
      TabOrder = 0
    end
  end
  inherited Panel2: TPanel
    Width = 853
    Caption = 'CONFER'#202'NCIA NOTAS FISCAIS ENTRADA'
  end
  inherited GroupBox1: TGroupBox
    object Label3: TLabel
      Left = 10
      Top = 104
      Width = 35
      Height = 16
      Caption = 'N'#186' NF'
    end
    object Label4: TLabel
      Left = 103
      Top = 104
      Width = 30
      Height = 16
      Caption = 'Serie'
    end
    object Label5: TLabel
      Left = 9
      Top = 60
      Width = 65
      Height = 16
      Caption = 'Fornecedor'
    end
    object Label6: TLabel
      Left = 11
      Top = 20
      Width = 31
      Height = 16
      Caption = 'Local'
    end
    object DBLCBFornecedor: TDBLookupComboBox
      Left = 9
      Top = 78
      Width = 432
      Height = 22
      Ctl3D = False
      KeyField = 'FORN_CODIGO'
      ListField = 'FORN_RAZAO'
      ListSource = DSFornecedor
      ParentCtl3D = False
      TabOrder = 0
    end
    object EdNF: TEdit
      Left = 9
      Top = 121
      Width = 86
      Height = 22
      Ctl3D = False
      MaxLength = 10
      ParentCtl3D = False
      TabOrder = 1
      OnKeyPress = EdNFKeyPress
    end
    object EdSERIE: TEdit
      Tag = 5
      Left = 102
      Top = 121
      Width = 36
      Height = 22
      Ctl3D = False
      MaxLength = 3
      ParentCtl3D = False
      TabOrder = 2
    end
    object DBLookupComboBox1: TDBLookupComboBox
      Left = 9
      Top = 37
      Width = 248
      Height = 22
      Ctl3D = False
      KeyField = 'LOC_CODIGO'
      ListField = 'LOC_DESCRICAO'
      ListSource = DSLocal
      ParentCtl3D = False
      TabOrder = 3
    end
    object GroupBox3: TGroupBox
      Left = 9
      Top = 150
      Width = 276
      Height = 54
      Caption = '  Per'#237'odo de Emiss'#227'o  '
      Ctl3D = False
      ParentCtl3D = False
      TabOrder = 4
      object Label7: TLabel
        Left = 135
        Top = 22
        Width = 7
        Height = 16
        Caption = 'a'
      end
      object Label8: TLabel
        Left = 8
        Top = 22
        Width = 16
        Height = 16
        Caption = 'De'
      end
      object DTINI: TDateEdit
        Left = 29
        Top = 22
        Width = 100
        Height = 21
        Ctl3D = False
        NumGlyphs = 2
        ParentCtl3D = False
        TabOrder = 0
      end
      object DTFIM: TDateEdit
        Left = 152
        Top = 22
        Width = 100
        Height = 21
        Ctl3D = False
        NumGlyphs = 2
        ParentCtl3D = False
        TabOrder = 1
      end
    end
  end
  inherited RLReport: TRLReport
    Left = 8
    Top = 45
    DataSource = DSPesquisa
    object RLBand2: TRLBand
      Left = 38
      Top = 120
      Width = 718
      Height = 22
      BandType = btColumnHeader
      Borders.Sides = sdCustom
      Borders.DrawLeft = False
      Borders.DrawTop = True
      Borders.DrawRight = False
      Borders.DrawBottom = True
      Borders.FixedTop = True
      Borders.FixedBottom = True
      object RLLabel2: TRLLabel
        Left = 122
        Top = 4
        Width = 107
        Height = 14
        Caption = 'Descri'#231#227'o de Entrada'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Height = -11
        Font.Name = 'Arial'
        Font.Style = []
        ParentFont = False
      end
      object RLLabel3: TRLLabel
        Left = 37
        Top = 4
        Width = 82
        Height = 14
        Caption = 'Ref. Fornecedor'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Height = -11
        Font.Name = 'Arial'
        Font.Style = []
        ParentFont = False
      end
      object RLLabel5: TRLLabel
        Left = 460
        Top = 4
        Width = 35
        Height = 14
        Caption = 'Quant.'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Height = -11
        Font.Name = 'Arial'
        Font.Style = []
        ParentFont = False
      end
      object RLLabel1: TRLLabel
        Left = 1
        Top = 4
        Width = 36
        Height = 14
        Caption = 'C'#243'digo'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Height = -11
        Font.Name = 'Arial'
        Font.Style = []
        ParentFont = False
      end
      object RLLabel4: TRLLabel
        Left = 326
        Top = 4
        Width = 65
        Height = 14
        Caption = 'Data Entrada'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Height = -11
        Font.Name = 'Arial'
        Font.Style = []
        ParentFont = False
      end
      object RLLabel6: TRLLabel
        Left = 411
        Top = 4
        Width = 31
        Height = 14
        Caption = 'N'#186' NF'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Height = -11
        Font.Name = 'Arial'
        Font.Style = []
        ParentFont = False
      end
      object RLLabel7: TRLLabel
        Left = 517
        Top = 4
        Width = 38
        Height = 14
        Caption = 'V. Unit.'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Height = -11
        Font.Name = 'Arial'
        Font.Style = []
        ParentFont = False
      end
      object RLLabel15: TRLLabel
        Left = 591
        Top = 4
        Width = 40
        Height = 14
        Caption = 'V. Total'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Height = -11
        Font.Name = 'Arial'
        Font.Style = []
        ParentFont = False
      end
      object RLLabel8: TRLLabel
        Left = 684
        Top = 3
        Width = 29
        Height = 14
        Caption = 'Local'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Height = -11
        Font.Name = 'Arial'
        Font.Style = []
        ParentFont = False
      end
    end
    object RLBand5: TRLBand
      Left = 38
      Top = 225
      Width = 718
      Height = 46
      BandType = btSummary
      Borders.Sides = sdCustom
      Borders.DrawLeft = False
      Borders.DrawTop = True
      Borders.DrawRight = False
      Borders.DrawBottom = False
      object RLDBResult1: TRLDBResult
        Left = 436
        Top = 1
        Width = 59
        Height = 14
        Alignment = taRightJustify
        AutoSize = False
        DataField = 'ITENS_NF_QUANTIDADE'
        DataSource = DSPesquisa
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Height = -11
        Font.Name = 'Arial'
        Font.Style = [fsBold]
        Info = riSum
        ParentFont = False
      end
      object RLDBResult2: TRLDBResult
        Left = 498
        Top = 1
        Width = 59
        Height = 14
        Alignment = taRightJustify
        AutoSize = False
        DataField = 'ITENS_NF_VALORUNITARIO'
        DataSource = DSPesquisa
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Height = -11
        Font.Name = 'Arial'
        Font.Style = [fsBold]
        Info = riSum
        ParentFont = False
      end
      object RLDBResult3: TRLDBResult
        Left = 572
        Top = 1
        Width = 59
        Height = 14
        Alignment = taRightJustify
        AutoSize = False
        DataField = 'ITENS_NF_VALORTOTAL'
        DataSource = DSPesquisa
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Height = -11
        Font.Name = 'Arial'
        Font.Style = [fsBold]
        Info = riSum
        ParentFont = False
      end
      object RLLabel9: TRLLabel
        Left = 392
        Top = 1
        Width = 33
        Height = 14
        Caption = 'Total:'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Height = -11
        Font.Name = 'Arial'
        Font.Style = [fsBold]
        ParentFont = False
      end
    end
    object RLGroup1: TRLGroup
      Left = 38
      Top = 142
      Width = 718
      Height = 83
      DataFields = 'NF_NOTAFISCAL'
      object RLBand3: TRLBand
        Left = 0
        Top = 0
        Width = 718
        Height = 25
        Borders.Sides = sdCustom
        Borders.DrawLeft = False
        Borders.DrawTop = False
        Borders.DrawRight = False
        Borders.DrawBottom = False
        object RLDBText3: TRLDBText
          Left = 121
          Top = 3
          Width = 204
          Height = 16
          AutoSize = False
          DataField = 'PROD_DESCRICAOENT'
          DataSource = DSPesquisa
          Font.Charset = DEFAULT_CHARSET
          Font.Color = clBlack
          Font.Height = -11
          Font.Name = 'Arial'
          Font.Style = []
          ParentFont = False
        end
        object RLDBText10: TRLDBText
          Left = 36
          Top = 3
          Width = 61
          Height = 14
          AutoSize = False
          DataField = 'PROD_REFERENCIA'
          DataSource = DSPesquisa
          Font.Charset = DEFAULT_CHARSET
          Font.Color = clBlack
          Font.Height = -11
          Font.Name = 'Arial'
          Font.Style = []
          ParentFont = False
        end
        object RLDBText12: TRLDBText
          Left = 450
          Top = 3
          Width = 44
          Height = 16
          Alignment = taRightJustify
          AutoSize = False
          DataField = 'ITENS_NF_QUANTIDADE'
          DataSource = DSPesquisa
          Font.Charset = DEFAULT_CHARSET
          Font.Color = clBlack
          Font.Height = -11
          Font.Name = 'Arial'
          Font.Style = []
          ParentFont = False
        end
        object RLDBText2: TRLDBText
          Left = 1
          Top = 3
          Width = 33
          Height = 14
          AutoSize = False
          DataField = 'PROD_CODIGO'
          DataSource = DSPesquisa
          Font.Charset = DEFAULT_CHARSET
          Font.Color = clBlack
          Font.Height = -11
          Font.Name = 'Arial'
          Font.Style = []
          ParentFont = False
        end
        object RLDBText11: TRLDBText
          Left = 329
          Top = 3
          Width = 60
          Height = 14
          Alignment = taCenter
          AutoSize = False
          DataField = 'NF_DATAESTOQUE'
          DataSource = DSPesquisa
          Font.Charset = DEFAULT_CHARSET
          Font.Color = clBlack
          Font.Height = -11
          Font.Name = 'Arial'
          Font.Style = []
          ParentFont = False
        end
        object RLDBText8: TRLDBText
          Left = 411
          Top = 3
          Width = 43
          Height = 16
          AutoSize = False
          DataField = 'NF_NOTAFISCAL'
          DataSource = DSPesquisa
          Font.Charset = DEFAULT_CHARSET
          Font.Color = clBlack
          Font.Height = -11
          Font.Name = 'Arial'
          Font.Style = []
          ParentFont = False
        end
        object RLDBText13: TRLDBText
          Left = 502
          Top = 3
          Width = 53
          Height = 16
          Alignment = taRightJustify
          AutoSize = False
          DataField = 'ITENS_NF_VALORUNITARIO'
          DataSource = DSPesquisa
          Font.Charset = DEFAULT_CHARSET
          Font.Color = clBlack
          Font.Height = -11
          Font.Name = 'Arial'
          Font.Style = []
          ParentFont = False
        end
        object RLDBText15: TRLDBText
          Left = 581
          Top = 3
          Width = 50
          Height = 16
          Alignment = taRightJustify
          AutoSize = False
          DataField = 'ITENS_NF_VALORTOTAL'
          DataSource = DSPesquisa
          Font.Charset = DEFAULT_CHARSET
          Font.Color = clBlack
          Font.Height = -11
          Font.Name = 'Arial'
          Font.Style = []
          ParentFont = False
        end
        object RLDBText4: TRLDBText
          Left = 635
          Top = 3
          Width = 78
          Height = 16
          Alignment = taRightJustify
          AutoSize = False
          DataField = 'LOC_DESCRICAO'
          DataSource = DSPesquisa
          Font.Charset = DEFAULT_CHARSET
          Font.Color = clBlack
          Font.Height = -11
          Font.Name = 'Arial'
          Font.Style = []
          ParentFont = False
        end
      end
      object RLBand4: TRLBand
        Left = 0
        Top = 25
        Width = 718
        Height = 18
        BandType = btSummary
        Borders.Sides = sdCustom
        Borders.DrawLeft = False
        Borders.DrawTop = False
        Borders.DrawRight = False
        Borders.DrawBottom = True
        object RLDBResult4: TRLDBResult
          Left = 436
          Top = 1
          Width = 59
          Height = 14
          Alignment = taRightJustify
          AutoSize = False
          DataField = 'ITENS_NF_QUANTIDADE'
          DataSource = DSPesquisa
          Font.Charset = DEFAULT_CHARSET
          Font.Color = clBlack
          Font.Height = -11
          Font.Name = 'Arial'
          Font.Style = [fsBold]
          Info = riSum
          ParentFont = False
        end
        object RLDBResult5: TRLDBResult
          Left = 498
          Top = 1
          Width = 59
          Height = 14
          Alignment = taRightJustify
          AutoSize = False
          DataField = 'ITENS_NF_VALORUNITARIO'
          DataSource = DSPesquisa
          Font.Charset = DEFAULT_CHARSET
          Font.Color = clBlack
          Font.Height = -11
          Font.Name = 'Arial'
          Font.Style = [fsBold]
          Info = riSum
          ParentFont = False
        end
        object RLDBResult6: TRLDBResult
          Left = 572
          Top = 1
          Width = 59
          Height = 14
          Alignment = taRightJustify
          AutoSize = False
          DataField = 'ITENS_NF_VALORTOTAL'
          DataSource = DSPesquisa
          Font.Charset = DEFAULT_CHARSET
          Font.Color = clBlack
          Font.Height = -11
          Font.Name = 'Arial'
          Font.Style = [fsBold]
          Info = riSum
          ParentFont = False
        end
        object RLLabel10: TRLLabel
          Left = 392
          Top = 1
          Width = 57
          Height = 14
          Caption = 'Sub Total:'
          Font.Charset = DEFAULT_CHARSET
          Font.Color = clBlack
          Font.Height = -11
          Font.Name = 'Arial'
          Font.Style = [fsBold]
          ParentFont = False
        end
      end
    end
  end
  inherited QPesquisa: TQuery
    Active = True
    SQL.Strings = (
      'select'
      'produto.prod_codigo,'
      'produto.prod_descricaoent,'
      'produto.prod_localizacao,'
      'produto.prod_referencia,'
      'produto.prod_unidsaida,'
      'notafiscal.nf_notafiscal,'
      'notafiscal.nf_serie,'
      'notafiscal.nf_local,'
      'notafiscal.nf_fornecedor_desc,'
      'notafiscal.nf_fornecedor,'
      'itensnotafiscal.itens_nf_quantidade,'
      'itensnotafiscal.itens_nf_valorunitario,'
      'itensnotafiscal.itens_nf_valortotal,'
      'notafiscal.nf_dataemissao,nf_dataestoque,'
      'notafiscal.data_cadastro,'
      'notafiscal.usuario_cadastro,'
      'notafiscal.nf_dataestoque,'
      'local.loc_descricao'
      'from notafiscal'
      
        'inner join itensnotafiscal on (itensnotafiscal.itens_nf_notafisc' +
        'al = notafiscal.nf_codigo)'
      
        'inner join produto on (produto.prod_codigo = itensnotafiscal.ite' +
        'ns_nf_produto)'
      'inner join local on (notafiscal.nf_local = local.loc_codigo)'
      'where (notafiscal.nf_situacao = 1)and'
      
        '      ((notafiscal.excluido <>  '#39'S'#39') AND (notafiscal.excluido is' +
        ' not null))  AND'
      
        '      ( NF_DATAEMISSAO between '#39'06/01/2012 00:00:00'#39' and '#39'06/13/' +
        '2012 23:59:59'#39' )'
      
        '      ORDER BY notafiscal.nf_notafiscal,notafiscal.nf_fornecedor' +
        '_desc')
    Left = 296
    Top = 257
  end
  inherited DSPesquisa: TDataSource
    Left = 272
    Top = 286
  end
  object DSFornecedor: TDataSource
    DataSet = DMGestao.QFornecedor
    Left = 328
    Top = 184
  end
  object DSLocal: TDataSource
    DataSet = DMGestao.QLocal
    Left = 392
    Top = 184
  end
end
